

DROP TABLE `hac_catalogo_actividades_comerciales_2`, `hac_catalogo_actividades_comerciales_3`;


update `facturas`  set `estrechazo` = 1 , `estenvio` = 1  where `estadoComprobanteIntegracion` = 3 and `estrechazo` = 0;
update `facturas_notas`  set  `estrechazo` = 1 , `estenvio` = 1 where `estadoComprobanteIntegracion` = 3 and `estrechazo` = 0;
update `facturas_notas_debito`  set  `estrechazo` = 1  , `estenvio` = 1 where `estadoComprobanteIntegracion` = 3 and `estrechazo` = 0;


 update `web_1001` set `UNIMED` = "G" WHERE `UNIMED` = 'g';
 update `web_1001` set `UNIMED` = "M" WHERE `UNIMED` = 'm';
 update `web_1001` set `UNIMED` = "Kg" WHERE `UNIMED` = 'kg';
 update `web_1001` set `UNIMED` = "D" WHERE `UNIMED` = 'd';
 update  `web_1001` set `cdgtar` =  "10" WHERE  `COB_IV` = 2;
 update  `web_1001` set `cdgtar` =  "10" ,  `COB_IV` = 2 WHERE  `ivporc` = 0;

 update `web_1001` set cdghac = "" WHERE cdghac = '2399999002200';
						   
 update `web_1001` set cdghac = "" WHERE cdghac = '3532902000000';
 update `web_1001` set cdghac = "" WHERE cdghac = '3532901000000';
 update  `web_1001` set `cdgtar` = "08" ,  `COB_IV` = 1   , `ivporc` = 13  WHERE  `ivporc` = "8.00" ;

 update  `web_0301` set `NUMTEL` = "88888888" WHERE `NUMTEL` = "00000000";
 UPDATE WEB_0301 SET DSCCLI = REPLACE(DSCCLI, ",", '');
 UPDATE facturas SET DSCCLI = REPLACE(DSCCLI, ",", '');

DELETE FROM `hac_tipo_tarifa` WHERE `hac_tipo_tarifa`.`cdgtar` = '05';
DELETE FROM `hac_tipo_tarifa` WHERE `hac_tipo_tarifa`.`cdgtar` = '06';
DELETE FROM `hac_tipo_tarifa` WHERE `hac_tipo_tarifa`.`cdgtar` = '07';


UPDATE web_0301 SET cdgact = LPAD(cdgact, 6, '0') WHERE CHAR_LENGTH(cdgact) = 5;
     

ALTER TABLE usuarios ADD perelilin INT(1) NOT NULL AFTER perfacneg;
ALTER TABLE facturas_notas ADD cdgbod INT(1) NOT NULL AFTER estrechazo;
ALTER TABLE seguimiento_articulo ADD cdgbod INT(1) NOT NULL AFTER can_nc;
ALTER TABLE facturas_compras ADD cdgbod INT(1) NOT NULL AFTER falcal;
ALTER TABLE seguimiento_comicion_facturas ADD tipo VARCHAR(3) NOT NULL AFTER monto;
ALTER TABLE `web_0301` ADD `artpro` DECIMAL(10,2) NOT NULL AFTER `salpunt`

ALTER TABLE web_0000 ADD percampre INT(1) NOT NULL AFTER tipcamaut;
ALTER TABLE web_0000 ADD regsimelec INT(1) NOT NULL AFTER percampre;
ALTER TABLE web_0000 ADD cantippre INT(1) NOT NULL AFTER facconred;
ALTER TABLE web_0000 ADD faccrcusd INT(1) NOT NULL AFTER regsimelec;
ALTER TABLE web_0000 ADD borprofac INT(1) NOT NULL AFTER faccrcusd;
ALTER TABLE web_0000 ADD comisipagcli INT(1) NOT NULL AFTER borprofac;
ALTER TABLE web_0000 ADD perbodega INT(1) NOT NULL AFTER comisipagcli;
ALTER TABLE `web_0000` ADD `artcomiva` INT(1) NOT NULL AFTER `perbodega`;  

ALTER TABLE `web_1001` ADD `ARTCONSIG` INT(1) NOT NULL AFTER `artpro`;
ALTER TABLE web_2101 ADD FECULTPAGINT DATE NOT NULL AFTER MODPRO;


ALTER TABLE `facturas` ADD `totivadev` DECIMAL(19,2) NOT NULL AFTER `totnosujeto`;
ALTER TABLE `facturas_notas` ADD `totivadev` DECIMAL(19,2) NOT NULL AFTER `totnosujeto`;
ALTER TABLE `web_1001` ADD `EXIACT1` FLOAT(9,2) NOT NULL AFTER `EXIACT`;
  
ALTER TABLE mensaje_receptor ADD totmernosuj DECIMAL(18,5) NOT NULL AFTER subtotexe;
ALTER TABLE mensaje_receptor ADD totnosujeto DECIMAL(18,5) NOT NULL AFTER totmernosuj;
ALTER TABLE mensaje_receptor ADD totnosujeto DECIMAL(18,5) NOT NULL AFTER totmernosuj;   

SOLO APLICAR SI NO ES FARMACIA O VETERINARIA 

 update  `web_1001` set `cdgtar` = "08" ,  `COB_IV` = 1   , `ivporc` = 13  WHERE  `ivporc` = "4.00" ;  

